USE [200Millas]
GO

/****** Object:  StoredProcedure [dbo].[usp_ConsultarEspecies]    Script Date: 10/06/2012 01:09:37 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

-- =============================================
-- Author:		<dparedes>
-- Create date: <2012/10/06>
-- Description:	<Consultar especie>
-- =============================================
CREATE PROCEDURE [dbo].[usp_ConsultarEspecies] 
@vcod_esp char(3)
AS
BEGIN
	SELECT * FROM [200Millas].dbo.TB_ESPECIE WHERE COD_ESP = @vcod_esp;
END

GO


USE [200Millas]
GO

/****** Object:  StoredProcedure [dbo].[usp_ListarEspecies]    Script Date: 10/06/2012 01:23:28 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

-- =============================================
-- Author:		<dparedes>
-- Create date: <2012/10/06>
-- Description:	<Listar especies>
-- =============================================
CREATE PROCEDURE [dbo].[usp_ListarEspecies] 
AS
BEGIN
	SELECT * FROM [200Millas].dbo.TB_ESPECIE;
END

GO



